﻿CREATE TABLE [ODCore].[SeriesCatalog] (
    [SeriesID]                    INT      IDENTITY (1, 1) NOT NULL,
    [FeatureID]                   INT      NOT NULL,
    [VariableID]                  INT      NOT NULL,
    [MethodID]                    INT      NOT NULL,
    [ObservationTypeID]           INT      NOT NULL,
    [IsCategorical]               BIT      NOT NULL,
    [SpatialRepresentationTypeID] INT      NOT NULL,
    [TimeSupportID]               INT      NOT NULL,
    [UnitID]                      INT      NOT NULL,
    [BeginDateTime]               DATETIME NOT NULL,
    [EndDateTime]                 DATETIME NOT NULL,
    [ObservationCount]            INT      NOT NULL,
    [OverallQualityIndicatorID]   INT      NOT NULL,
    [DateCreated]                 DATETIME NOT NULL,
    [DateModified]                DATETIME NOT NULL,
    [DateFinalized]               DATETIME NULL,
    [UpdateFrequency]             INT      NULL,
    [UpdateFrequencyUnit]         INT      NULL,
    [OriginatorID]                INT      NOT NULL
);

